Human Resources Tables

 

The Table Type EntityView class contains static constant values to provide enumerations, properties, and methods to support working with Table Type information.

TableType
Static Enum/Constant (bigint) Value Description
ActivityCode 1 Activity Code
AttributeGroup 2 Attribute Group
BenefitType 3 Benefit Type
Citizenship 4 Citizenship
DegreeType 5 Degree Type
DirectCareStat 6 Direct Care Status
EducationLevel 7 Education Level
Ethnicity 8 Ethnicity
ExemptStatus 9 Exemption Status
FMLADelivMeth 10 FMLA Delivery Method
FMLALeaveReason 11 FMLA Leave Reason
FMLALeaveType 12 FMLA Leave Type
FMLALocation 13 FMLA Location
FMLAStatus 14 FMLA Status
Frequency 15 Frequency
Gender 16 Gender
HealthCarriers 17 Health Insurance Carriers
IndStatus 18 Individual Status
JobCategory 19 Job Category
LicenseType 20 License Type
LifeCarriers 21 Life Insurance Carriers
MarStatus 22 Marital Status
PosChange 23 Position Change Reason
PosDivision 24 Position Division
PositionCase 25 Position Case Type
PositionType 26 Position Type
PosLocation 27 Position Location
PosProgram 28 Position Program
PremiumMethod 29 Premium Method
ProcessList 30 Process Checklist
RelationCode 31 Relation Code
RetireTrust 32 Retirement Trustees
Skills 33 Skills
TrainingCode 34 Training Code
TrainingType 35 Training Type
VeteranStatus 36 Veteran Status
WorkersComp 37 Workers Compensation
ProcessType 38 Process Type
     
Properties    
ID R/W, Int64, ID of current table entity
Description R/W, String, Lookup of localized description of given table ID
MapToStandard R/O, bool, True when standard codes exist for the table ID
StandardCodes List of Standard codes assigned to the table ID (EntityList<TypeCodeStandard>)
     
Methods    
CopyToServer (TransMan) Static method to copy the known list of Table Types into a temporary table on the SQL server. Builds and populates #TableTypes(ID, Description, MapToStandard)
GetTableTypeList() Static EntityList<TableType>; Returns the known set of Table Type values. Contains an entry for each static constant/enumeration value.
HasStandardCode (int64 tableId) Static bool; Uses the list of Standard Code mappings provided by TypeCodeStandard to identify if the table has standard codes.
GetStandardCodeList (Int64 tableId) Static EntityList<TypeCodeStandard>; Returns the list of Standard Codes for the given table ID

The Type Code Standard EntityView class contains static constant values to provide enumerations, properties, and methods to support working with Standard Type Code information.

TypeCodeStandard
     
Properties    
ID R/W, Int64, ID of current Type Code entity
TableID R/W, Int64, ID of the parent Table Type for the standard codes
TypeCode R/W, String, Standard Code value
Description R/W, String, Lookup of localized description of given standard code ID
     
Methods    
CopyToServer (TransMan) Static method to copy the known list of Standard Codes into a temporary table on the SQL server. Builds and populates #StandardCodes (ID, TableID, TypeCode, Description)
GetStandardCodeList() Static EntityList<TypeCodeStandard>; Returns the known set of Standard Code values.
HasStandardCode (int64 tableId) Static bool; Uses the list of Standard Code mappings provided by TypeCodeStandard to identify if the table has standard codes.
GetStandardCodeList (Int64 tableId) Static EntityList<TypeCodeStandard>; Returns the list of Standard Codes for the given table ID
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
AttributeGroupTypeCodeId varchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
HeathInsID int     System Generated ID  
FrequencyTypeCodeId varchar 10      
CarrierTypeCodeID varchar 10      
EmployeeContribution pDec        
EmployerContribution pDec        
MaximumAgeEmployee int        
MaximumAgeDependent int        
WaitingPeriod int        
MaxOutOfPocket pDec        
MaxBenefit pDec        
MajorMedicalCoverage int        
COBRAPremium pDec        
CoPayList       EntityList of HealthCoPay child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
HealthInsId pHealthInsID        
Amount pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
JobCatTypeCodeId varchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
LeavePlanDetailList       EntityList of LeavePlanDetail child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
LeavePlanID pLeavePlanID        
LeaveCode          
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
FrequencyTypeCodeID varchar 10      
CarrierTypeCodeID varchar 10      
CoverageMaxAmount pDec        
WaitingPeriod int        
LifeInsurancePremiumMethod tinybit 1     0 = Fixed, 1 = AgeBased
Sublist       EntityList of LifeInsSub child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
LifeInstID pLifeID        
MaxAge int        
SelfSEmployerAmount pDec        
SelfSEmployeeAmount pDec        
SelfNSEmployerAmount pDec        
SelfNSEmployeeAmount pDec        
SpouseSEmployerAmount pDec        
SpouseSEmployeeAmount pDec        
SpouseNSEmployerAmount pDec        
SpouseNSEmployeeAmount pDec        
ChildSEmployerAmount pDec        
ChildSEmployeeAmount pDec        
ChildNSEmployerAmount pDec        
ChildNSEmployeeAmount pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
JobTypeCodeId varchar 10      
Department pDeptID 10      
MinEdLevelTypeCodeID varchar 10      
CountyDirectCareStatusTypeCodeID varchar 10      
PositionHoursBudgeted pDec        
SalaryBudgeted pDec        
SupervisorPositionId varchar        
WageHourExemptStatusTypeCodeID varchar 10      
WorkersCompensationTypeCodeID varchar 10      
PositionTypeCodeID varchar 10      
PositionCaseTypeCodeID varchar 10      
PositionActiveDate datetime 8      
PositionInactiveDate datetime 8      
DivisionTypeCodeID varchar 10      
ProgramTypeCodeID varchar 10      
LocationTypeCodeID varchar 10      
CheckSort pSort 10      
DefaultEarningCode pCode 3      
LeavePlanID varchar 10      
EarnCodeList       EntityList of PostionEarnCode child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
PositionID pPosition        
EarnCodeID pCode        
Rate pDec        
EarningRateType bit 1     0 = None, 1 = PercentOfRegularRate, 2 = OverrideRegularRate
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
ProcessTypeCodeID varchar 10      
ChecklistTypeCodeID varchar 10      
PersonResponsible pIndiv        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
FrequencyTypeCodeId varchar 10      
TrusteeTypeCodeID varchar 10      
EmployerMatchPercent pDec        
EmployerMatchMax pDec        
MinimumAge int        
MaxContribution pDec        
WaitingPeriod int        
MaxContribution pDec        
FundList       EntityList of RetirementFund child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
RetPlanId pPlan 10      
Description varchar 50      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
FrequencyTypeCodeId varchar 10      
CategoryList       EntityList of ReviewTypeCat child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
ReviewTypeID pType        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
RecertificationMonths int        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
TableID          
StandardID          
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
SSNUnprotected       Property to expose the Unprotected/Decrypted version of the SSN.  
SSN       Edit permission set via business rule  
DOB datetime 8      
EthnicityTypeCodeID varchar 10      
GenderTypeCodeID varchar 10      
MaritalStatusTypeCodeID varchar 10      
VeteranStatusTypeCodeID varchar 10      
StartDate datetime 8      
TerminationDate datetime 8      
Manager varchar        
LaborClass pClass        
CitizenshipTypeCode varchar 10      
WorkAuthorizationExpiration datetime 8      
PayDistributionType tinyint 1 0   0 = None, 1 = Amount, 2 = Percent
ActivityList       EntityList of IndActivity child entities  
AttributeList       EntityList of IndAttribute child entities  
DegreeList       EntityList of IndDegree child entities  
DependentList       EntityList of IndDependent child entities  
FMLAList       EntityList of IndFMLA child entities  
HealthList       EntityList of IndHealth child entities  
LicenseList       EntityList of IndLicense child entities  
LifeInsList       EntityList of IndLifeIns child entities  
PayDistributionList       EntityList of IndPayDistribution child entities  
PositionList       EntityList of IndPosition child entities  
ProcessList       EntityList of IndProcess child entities  
PropertyList       EntityList of IndProperty child entities  
RetirementList       EntityList of IndRetirement child entities  
ReviewList       EntityList of IndReview child entities  
SalaryList       EntityList of IndSalary child entities  
SkillList       EntityList of IndSkill child entities  
StatusList       EntityList of IndStatus child entities  
TestList       EntityList of IndTest child entities  
TrainingList       EntityList of IndTraining child entities  
WithholdFederalList       EntityList of IndWithholdFederal child entities  
WithholdLocalList       EntityList of IndWithholdLocal child entities  
WithholdStateList       EntityList of IndWithholdState child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
ActivityTypeCodeID varchar 10      
ActivityDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
AttributeGroupTypeCodeID varchar 10      
AttributeGroupDetailID varchar 10      
AttributeDate datetime 8      
Amount1 pDec        
Amount2 pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
DegreeTypeCodeID varchar 10      
DateAcquired datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
RelationTypeCodeID varchar 10      
DOB datetime 8      
GenderTypeCodeID varchar 10      
SSN       Edit permission set via business rule  
SSNUnprotected       Property to expose the Unprotected/Decrypted version of the SSN.  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
IndId pID 10      
WithholdId pWithhold 10      
Code pCode 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
NotifyDate datetime 8      
ERResponseDate datetime 8      
DesigNoticeDate datetime 8      
LeaveBegDate datetime 8      
ExpReturnDate datetime 8      
LeaveReasonTypeCodeID varchar 10      
LeaveTypeCodeID varchar 10      
LocationTypeCodeID varchar 10      
MedCertDueDate datetime 8      
MedCertRecDate datetime 8      
ExpDate datetime 8      
FMLAStatusTypeCodeID varchar 10      
DeliveryMethodTypeCodeID varchar 10      
FMLAHrsPerWeek pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
HealthInsID varchar 10      
BenefitStartDate datetime 8      
BenefitEndDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
LicenseTypeCodeID varchar 10      
LicenseExpDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
LifeInsID varchar 10      
BenefitStartDate datetime 8      
BenefitEndDate datetime 8      
BeneficiaryPct1 pDec        
BeneficiaryPct2 pDec        
ContingencyPct1 pDec        
ContingencyPct2 pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
IndId pID 10      
WithholdID varchar 10      
Code pCode 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
AccountNumberUnprotected       Property to expose the Unprotected/Decrypted version of the Account Number.  
RoutingCode nvarchar 9      
AmountPercent pDec 8      
PayDistributionAccountType tinyint 1     0 = Paycheck, 1 = Checking, 2 = Savings
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
IndId pID 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
PositionID varchar 10      
ChangeReasonTypeCodeID varchar 10      
StartDate datetime 8      
EndDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
ProcessTypeCodeID varchar 10      
ProcessGroupDetailCodeID varchar 10      
PersonResponsible pID 10      
DateCompleted datetime 8      
ProcessStatus         0 = Incomplete, 1 = Complete
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
PropertyCodeID varchar 10      
StartDate datetime 8      
EndDate datetime 8      
Value pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
RetplanID varchar 10      
StartDate datetime 8      
EndDate datetime 8      
AllocMethodTypeCodeID varchar 10      
PreTaxNumber pDec        
AfterTaxNumber pDec        
LoanAmount pDec        
AllocationList       EntityList of IndRetFundAllocation child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
RetirementId pRetID 10      
RetFundID varchar 10      
Allocation pDec 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
ReviewTypeID varchar 10      
ReviewDate datetime 8      
Next ReviewDate datetime 8      
CalculateNextReviewDate       use current ReviewDate and the Standard Code for the review Frequency  
CategoryList       EntityList of IndReviewByCategory child entities  
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ReviewID pReviewID     System Generated ID  
ReviewTypeCatID varchar 10      
Weight pDec        
Rating pDec        
Score pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
EffectiveDate datetime 8      
Salary pDec        
HourlyRate pDec        
IndividualPayType tinybit 1     0 = Hourly, 1 = Salaried
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
SkillTypeCodeID varchar 10      
DateAcquired datetime 8      
Hours pDec        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
StartDate datetime 8      
IndStatusTypeCodeID varchar 10      
LeavePlanID varchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
TestTypeID varchar 10      
DateAcquired datetime 8      
RecertificationDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
TrainingCodeID varchar 10      
DateAcquired datetime        
TrainingTypeID varchar 10      
Hours pDec        
EventCost pDec        
TravelCost pDec        
DeptID pDept 10      
RecertificationDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID int     System Generated ID  
IndId pID 10      
TaxAuthorityID pTaxID 10      
MaritalStatus pStatus 8      
Exemptions int        
ExtraWithholding pDec        
FixedWithholding pDec        
SUIState          
EICCode          
CF xml -1      
ts timestamp 8      
*Federal/State/Local       Refer to the PA implementation of Federal, State, and Local derivations of the type specific Withholding entity.